Nested formulas

For dynamic aggregation, formulas can be nested within other formulas and linked to a formula channel. When running an aggregation on a dynamic group, data will be returned for each interval that meets the conditions of at least one formula in the sequence of nested formulas. Formulas may be nested up to seven (7) levels.

For a highly simplified example, this named formula contains nested formulas:

This named formula is then linked to a formula channel:

The MAX values of each of the service point channels in the dynamic group are 100, 200, and 300. The maximum value in the channel is 300, but the IMAX function in the formula specifies that only values equal to or greater than 600 will be returned, so none of the intervals in each of the service point channels will return data.

However, there is also an ISUM function nested in the formula. The sum of the values of the service point channels is 100 + 200 + 300 = 600, so data is returned for all intervals in the group whose value is equal to or greater than 600.